/***********************************************************************************************************************************
 * Name:	SSRS_EnableRemoteErrors.sql
 * Author:	Frank Figearo (frank@sqlnerd.me)
 * Summary:	Enable Remote Errors in SQL Reporting Services.
 * Hat Tip:	http://sharepointjon.blogspot.com/2008/09/enabling-remote-errors-in-sql-reporting.html
 */
SET IMPLICIT_TRANSACTIONS OFF; WHILE 0 < @@TRANCOUNT ROLLBACK;
UPDATE ReportServer.dbo.ConfigurationInfo
  SET Value= 'True'
  WHERE Name = 'EnableRemoteErrors';
GO